IF OBJECT_ID(N'ProcName', N'P') IS NULL
BEGIN
    EXEC ('CREATE PROCEDURE [dbo].[ProcName] AS BEGIN SELECT 1 END')
END
GO

ALTER PROCEDURE ProcName(@Paras INT)
AS
BEGIN
	SELECT 'example'
END
GO